<?php

`git config --global user.name "廉东方"`;
`git config --global user.email "sxldfang@126.com"`;
`net start mysql`;
$db = new PDO('mysql:host=localhost', 'root', '12qwas');
$r = $db->exec('create database if not exists db');
$r = $db->exec('use db');
$r = $db->exec('create table if not exists students(xh varchar(9) primary key not null, name varchar(50) not null, tel char(11) not null)');
$r = $db->exec("delete from students where xh='233110201'");
var_dump($r);
$db->exec('truncate table students');//删除表中的所有数据
$r = $db->exec("insert into students(xh,name,tel) values('233110201','张三','13333333333'),('233110202','李四','13444444444'),('233110203','王五','13555555555')");
var_dump($r);
$r = $db->exec("update students set name='张三丰' where xh='233110201'");
var_dump($r);